package dao.v2;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import model.AddressVO;
import model.LogPackageVO;
import model.MemberMsgVO;
import model.MemberVO;
import model.PackageVO;
import model.PageEarnVO;

public interface MemberVOMapper {

	MemberVO getMemberByTel(MemberVO memberVO);

	MemberVO login(MemberVO memberVO);

	void updateTokenAndLogin(Map<String, String> map);

	MemberVO smsLogin(MemberVO memberVO);

	int insert(MemberVO memberVO);

	void updatePwd(MemberVO memberVO);

	MemberVO getMemberAwardById(String member_id);

	MemberVO getLevelByMemberId(String member_id);

	String getSpecificChildNum(@Param("member_id")String member_id, @Param("level_id")String level_id);

	String getChildrenNum(@Param("id")String id, @Param("re")String re);

	MemberVO getMasterMemberInfo(String member_id);

	MemberVO getCurMemberInfo(String member_id);

	List<MemberVO> getLevlupInfo(@Param("loadPropertie")String loadPropertie, @Param("history_total_ticket")String history_total_ticket);

	MemberVO getLoginMemberById(String id);

	void updateTel(MemberVO memberVO);

	int checkTel(MemberVO memberVO);

	int checkPwd(MemberVO memberVO);

	void updatePwdById(MemberVO memberVO);

	void updatePayPwdById(MemberVO memberVO);

	void updateIdCardInfo(MemberVO memberVO);

	MemberVO getMemberByTelNoInviteno(MemberVO memberVO);

	void updateMemberInfo(MemberVO memberVO);

	MemberVO getMemberInfoByTel(String tel);

	MemberVO getIdcardInfo(String member_id);

	int checkMemberInChildren(@Param("id")String id, @Param("member_id")String member_id);

	void updateInvitedBy(MemberVO memberVO);

	int checkTokenTime(@Param("token")String token,@Param("member_id")String member_id);

	MemberVO getDrawAccount(String member_id);

	void updateDrawAccountAlipay(@Param("member_id")String member_id,@Param("type")String type, @Param("account")String account, @Param("name")String name, @Param("bank_id")String bank_id);

	int chekPayPwd(MemberVO memberVO);

	int checkFreeCash(MemberVO memberVO);

	String selectSpecialYn(String member_id);

	MemberVO checkLoginTime(@Param("member_id")String member_id, @Param("day_num")String day_num, @Param("os") String os);

	void updateLastLoginTime(@Param("member_id") String member_id, @Param("os") String os);

	MemberVO getInvitedMemberInfo(String member_id);

	List<MemberVO> getChildListByParent(MemberVO memberVO);

	MemberVO getInfoById(String parent_id);

	int getTotal(MemberVO memberVO);

	MemberVO getAllInfoById(String member_id);

	MemberVO getLoginMemberByOpenId(String open_id);
	
	int getPackage(String package_id);
	
	void insertLogPackage(LogPackageVO log);
	
	void updMemberLevel(@Param("member_id")String member_id, @Param("vip_level")String vip_level, @Param("level")String level, @Param("primary_level") String primary_level);

	double getCurMonthProfit(String member_id);

	void regPushId(@Param("member_id") String member_id, @Param("push_id") String push_id);

	String getCidById(String id);
	
	PackageVO getGoodPackage(@Param("package_id")String package_id,@Param("standard_id")String standard_id);

	int checkInviteNo(String invite_no);

	MemberVO getMemberInfoById(String invite_no);

	void updateOpenId(MemberVO vo);

	String getInvitenoByOpenid(String open_id);
	
	PackageVO getGoodPackageNostandardId(String pakcage_id);

	String getAlipayFee(String string);

	String selectMemberOpenid(String member_id);

	int getMemberNumByTel(MemberVO memberVO);

	void deleteMember(String id);

	double getfreeCash(String member_id);

	void updatePersonalSign(MemberVO memberVO);

	MemberVO getSimpleInfoById(String member_id);

	MemberVO getMemberByIdWechat(@Param("member_id") String member_id, @Param("token") String token);

	int checkTimeOverOneHour(@Param("member_id") String member_id, @Param("os") String os);

	void updataMyWindowShareTimes(String member_id);

	void newUpdateIdCardInfo(MemberVO memberVO);

	MemberVO getMemberByIdCheck(@Param("member_id") String member_id, @Param("token") String token, @Param("os") String os);

	String getChildIds(String member_id);

	String getInvitedByUpdate(@Param("member_id") String member_id, @Param("childs") String childs, @Param("primary_level") String primary_level);

	MemberVO getLoginMemberByQQId(String qq_id);

	MemberVO getLoginMemberBySinaId(String sina_id);

	void updateSinaId(MemberVO memberVO);

	void updateQQId(MemberVO memberVO);

	String getUpExpertNum(@Param("member_id") String member_id ,@Param("child_ids") String child_ids, @Param("expert_level") String expert_level);

	void insertMsgConn(MemberVO memberVO);

	MemberVO selectmMemberTable(String member_id);

	String getInvitenoById(String header_member_id);

	MemberVO getSxMemberVOInfo(String invited_by);

	String getInvited_by(String invite_no);

	MemberVO seleceMemerSomeInfo(String member_id);

	List<Map<String, Object>> getOpenIdAll();

	void updateOpendIdBatch(@Param("openid") String openid, @Param("uid") String uid);

	void updataPushOpenId(@Param("member_id")String member_id, @Param("push_open_id")String push_open_id);

	void insertOpenIdAndPushOpenId(@Param("push_open_id")String push_open_id,@Param("union_id") String union_id);

	MemberVO selectMemberInfoByUnionId(String union_id);

	String getNikeName(String memberId_x);

	List<String> getShangXianMemberId(String connNo);

	List<String> getShangXianMemberIdByOrderId(String order_id);

	void updatePushOpenId(@Param("id") String id, @Param("push_open_id") String push_open_id);

	void deleteMemberOpenByUnionId(String union_id);

	String getNickName(String create_by);

	String getNickNameByConnNO(String connNo);

	String getInvitedByById(String id);

	MemberVO getSimpleInfoByInviteNo(String invite_no);

	MemberVO getCartCity(String member_id);

	MemberVO getCityParentCity(String id);

	String getCartAddress(String member_id);


	AddressVO getMemberAddressById(String address_id);

	AddressVO getMemberAddressByMemberId(String member_id);

	AddressVO getMemberDefaultAddress(String member_id);

	String getMemberAddress(String address_id);

	void updataDeliveryAddress(@Param("city_id")String city_id, @Param("address_id")String address_id, @Param("member_id")String member_id);

	String getCityId(String address_id);

	void updataDefaultDeliveryAddress(String member_id);

	int selectMemberCart(String address_id);

	int selectLibCity(String city_id);

	String selectCityId(String address_id);

	MemberMsgVO getMemberMsgAllInfo(String id);

	void updataMsgVoIosExpMsg(String id);

	void updataMsgVoAndroidExpMsg(String id);

	void updataMsgVoWechatExpMsg(String id);

	void updataMsgVoWebExpMsg(String id);

	void updataMsgVoIosExpPast(String id);

	void updataMsgVoAndroidExpPast(String id);

	void updataMsgVoWechatExpPast(String id);

	void updataMsgVoWebExpPast(String id);

	List<PageEarnVO> getSuperBuyers(@Param("lang")String lang);

	List<MemberVO> selectChildList(MemberVO memberVO);
	
	MemberVO getMemberByTelAndCountry(MemberVO memberVO);

	int getMemberCountByTelAndCountry(MemberVO memberVO);

	void updataAddress(@Param("city_id")String city_id3, @Param("address_id")String address_id, @Param("member_id")String member_id);

	int updateChildLevel(@Param("child_member_id")String child_member_id,  @Param("level")String level);

	int getChildListTotal(MemberVO memberVO);
	
	int getChildListTotalByLevel(MemberVO memberVO);

	List<MemberVO> selectChildListByLevle(MemberVO memberVO);
	
	void insertLogExp(@Param("child_member_id")String child_member_id, @Param("level")String level, @Param("member_id")String member_id);
	
	MemberVO getAllByInviteNo(String invite_no);
	
	MemberVO getAllInfoByTelAndCountry_id(@Param("tel")String tel,@Param("country") String country);

	void updateExpMsg(String id);

	void updataDeliveryAddress1(String member_id);

	void updataMsgVoIosExpMemberMsg(String id);

	void updataMsgVoAndroidExpMemberMsg(String id);

	void updataMsgVoWechatExpMemberMsg(String id);

	void updataMsgVoWebExpMemberMsg(String id);

	MemberVO getLoginMemberByGoogleId(String google_id);

	void updateGoogleId(MemberVO memberVO);

	MemberVO getLoginMemberByFacebookId(String facebook_id);

	void updateFacebookId(MemberVO memberVO);

	MemberVO getLoginMemberByVkontakteId(String vkontakte_id);

	void updateVkontakteId(MemberVO memberVO);

	void updatePayPal(MemberVO memberVO);

	void updateInterAlipay(MemberVO memberVO);

	void updateInterBank(MemberVO memberVO);

	int checkFreeCashEn(MemberVO memberVO);

	void updateInterIdCardInfo(MemberVO memberVO);

	MemberVO getInterIdcardInfo(String member_id);

	void updataDefaultDeliveryAddressEn(String member_id);

	MemberVO getCityParentCityEn(String city_id);

	MemberVO getCartCityEn(String member_id);

	AddressVO getMemberDefaultAddressEn(String member_id);

	AddressVO getMemberAddressByMemberIdEn(String member_id);

	String getCityIdEn(String address_id);

	String getMemberAddressEn(String address_id);

	void updataDeliveryAddress1En(@Param("member_id")String member_id,@Param("city_id")String city_id);

	int selectMemberCartEn(String address_id);

	AddressVO getMemberAddressByIdEn(String address_id);

	MemberVO getDrawAccountInter(String member_id);

	void updataDeliveryAddressEn(@Param("city_id")String city_id, @Param("address_id")String address_id, @Param("member_id")String member_id);
}
